from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class LandTransferDetail(Base):
    __tablename__ = "TYC_M_LAND_TRANSFER_DETAIL"
    ID = Column(String(255))
    AREA = Column(String(255))
    MERCHANDISE_TIME = Column(String(255))
    YEARS_OF_USE = Column(String(255))
    LEVEL = Column(String(255))
    NUM = Column(String(255))
    AMINISTRATIVEAREA = Column(String(255))
    USER_CHANGE_PRE_CLEAN = Column(String(4000))
    MERCHANDISE_PRICE = Column(String(255))
    USE_TYPE = Column(String(255))
    USER_CHANGE_NOW_CLEAN = Column(String(255))
    LOCATION = Column(String(255))
    USEFUL = Column(String(255))
    MERCHANDISE_TYPE = Column(String(255))
    MARK = Column(String(500))
    SITUATION = Column(String(500))

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)